--------------------------------------------------------
--  DDL for View LOOKAHEAD_1YR
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "EVRS_OX"."LOOKAHEAD_1YR" ("EFIS_ID", "HQ_CATEGORY",
  "DISTRICT_CODE", "EA5", "IS_MILESTONE", "IMPL_AGENCY_DED",
  "IMPL_AGENCY_PAED", "IMPL_AGENCY_RWC", "IMPL_AGENCY_RTL", 
  "IMPL_AGENCY_CCA", "IMPL_AGENCY_EP", "CT_CTRESP_DED",
  "CT_CTRESP_PAED", "CT_CTRESP_RWC", "CT_CTRESP_RTL", 
  "CT_CTRESP_CCA", "CT_CTRESP_EP", "CT_COUNTY", "CT_ROUTE",
  "CT_POST_BEGIN_TYPE", "CT_POST_STA", "CT_POST_END_TYPE",
  "CT_POST_END", "PROJ_MGR", "CT_WORK_DESC_LONG", "DED_MILESTONE",
  "DED_FINISH_DATE", "DED_PERCENT_COMP", "PAED_MILESTONE",
  "PAED_FINISH_DATE", "PAED_PERCENT_COMP", "RWC_MILESTONE", 
  "RWC_FINISH_DATE", "RWC_PERCENT_COMP", "RTL_MILESTONE",
  "RTL_FINISH_DATE", "RTL_PERCENT_COMP", "CCA_MILESTONE",
  "CCA_FINISH_DATE", "CCA_PERCENT_COMP", "EP_MILESTONE",
  "EP_FINISH_DATE", "EP_PERCENT_COMP", "CT_STATUS", "PSE_MILESTONE",
  "PSE_FINISH_DATE", "PSE_PERCENT_COMP", "PSE_DOE_MILESTONE", 
  "PSE_DOE_FINISH_DATE", "PSE_DOE_PERCENT_COMP", "ADV_MILESTONE",
  "ADV_FINISH_DATE", "ADV_PERCENT_COMP", "AWD_MILESTONE", "AWD_FINISH_DATE",
  "AWD_PERCENT_COMP", "HQ_CATEGORY_2", "HQ_CATEGORY_3", "HQ_CATEGORY_4",
  "HQ_CATEGORY_5", "HQ_CATEGORY_6", "HQ_CATEGORY_7", "HQ_CATEGORY_8",
  "HQ_CATEGORY_9", "HQ_CATEGORY_10", "PN", "L_WRKLOAD", "L_AUTH", "L_DP",
  "L_CFD", "L_RESOURCE", "L_CURFYOP", "L_BASELINE", "DOC_KEY", "REGION",
  "CT_CAP_ROADK", "CT_STRUC_CAPK", "CT_ROW_CAPK", "RW_CAP", "CON_CAP",
  "ENV", "DES", "RW", "CON", "CON_CAP_FUTURE", "ENV_DOLLAR_EXP",
  "DES_DOLLAR_EXP", "RWS_DOLLAR_EXP", "CON_DOLLAR_EXP", "RPM_DOLLAR_EXP",
  "CNC_DOLLAR_EXP", "RWC_DOLLAR_EXP", "BASELINE_MS", "DOCUMENT", "ENV_ETC",
  "DES_ETC", "RW_ETC", "CON_ETC", "STD_ETC", "STC_ETC", "STE_ETC", 
  "STR_ETC", "STC_DOLLAR_EXP", "STD_DOLLAR_EXP", "STE_DOLLAR_EXP",
  "STR_DOLLAR_EXP", "CON_EAC", "RW_EAC", "DES_EAC", "ENV_EAC", 
  "STD_EAC", "STC_EAC", "STE_EAC", "STR_EAC", "CT_PROG", "CT_AADD",
  "CT_PPNO", "DOCYEAR", "LINEYEAR", "PROGCODE", "NOP_MILESTONE", 
  "NOP_FINISH_DATE", "NOP_PERCENT_COMP") AS 
 SELECT "EFIS_ID","HQ_CATEGORY","DISTRICT_CODE","EA5","IS_MILESTONE","IMPL_AGENCY_DED","IMPL_AGENCY_PAED","IMPL_AGENCY_RWC","IMPL_AGENCY_RTL","IMPL_AGENCY_CCA","IMPL_AGENCY_EP","CT_CTRESP_DED","CT_CTRESP_PAED","CT_CTRESP_RWC","CT_CTRESP_RTL","CT_CTRESP_CCA","CT_CTRESP_EP","CT_COUNTY","CT_ROUTE","CT_POST_BEGIN_TYPE","CT_POST_STA","CT_POST_END_TYPE","CT_POST_END","PROJ_MGR","CT_WORK_DESC_LONG","DED_MILESTONE","DED_FINISH_DATE","DED_PERCENT_COMP","PAED_MILESTONE","PAED_FINISH_DATE","PAED_PERCENT_COMP","RWC_MILESTONE","RWC_FINISH_DATE","RWC_PERCENT_COMP","RTL_MILESTONE","RTL_FINISH_DATE","RTL_PERCENT_COMP","CCA_MILESTONE","CCA_FINISH_DATE","CCA_PERCENT_COMP","EP_MILESTONE","EP_FINISH_DATE","EP_PERCENT_COMP","CT_STATUS","PSE_MILESTONE","PSE_FINISH_DATE","PSE_PERCENT_COMP","PSE_DOE_MILESTONE","PSE_DOE_FINISH_DATE","PSE_DOE_PERCENT_COMP","ADV_MILESTONE","ADV_FINISH_DATE","ADV_PERCENT_COMP","AWD_MILESTONE","AWD_FINISH_DATE","AWD_PERCENT_COMP","HQ_CATEGORY_2","HQ_CATEGORY_3","HQ_CATEGORY_4","HQ_CATEGORY_5","HQ_CATEGORY_6","HQ_CATEGORY_7","HQ_CATEGORY_8","HQ_CATEGORY_9","HQ_CATEGORY_10","PN","L_WRKLOAD","L_AUTH","L_DP","L_CFD","L_RESOURCE","L_CURFYOP","L_BASELINE","DOC_KEY","REGION","CT_CAP_ROADK","CT_STRUC_CAPK","CT_ROW_CAPK","RW_CAP","CON_CAP","ENV","DES","RW","CON","CON_CAP_FUTURE","ENV_DOLLAR_EXP","DES_DOLLAR_EXP","RWS_DOLLAR_EXP","CON_DOLLAR_EXP","RPM_DOLLAR_EXP","CNC_DOLLAR_EXP","RWC_DOLLAR_EXP","BASELINE_MS","DOCUMENT","ENV_ETC","DES_ETC","RW_ETC","CON_ETC","STD_ETC","STC_ETC","STE_ETC","STR_ETC","STC_DOLLAR_EXP","STD_DOLLAR_EXP","STE_DOLLAR_EXP","STR_DOLLAR_EXP","CON_EAC","RW_EAC","DES_EAC","ENV_EAC","STD_EAC","STC_EAC","STE_EAC","STR_EAC","CT_PROG","CT_AADD","CT_PPNO","DOCYEAR","LINEYEAR","PROGCODE","NOP_MILESTONE","NOP_FINISH_DATE","NOP_PERCENT_COMP" from CIP_OX 
  WHERE HQ_CATEGORY='AUTHORIZED' and IMPL_AGENCY_RTL='CT'
    AND ADV_FINISH_DATE BETWEEN (SYSDATE) AND (SYSDATE+365);
